﻿
CREATE TABLE [dbo].[ZipInfo](
	[ZipID] [int] NOT NULL,
	[ZipCode] [varchar] (5) NOT NULL,
	[ActiveLeadCount] [int] NOT NULL,
	[LapsedLeadCount] [int] NOT NULL,
	[BusinesLeadCount] [int] NOT NULL,
	[NeighborLeadCount] [int] NOT NULL,
	[State] [varchar] (2) NULL,
	[City] [varchar] (27) NULL,
	[County] [varchar] (27) NULL,
	[Division] [nvarchar](2) NULL,
	[Market] [varchar] (2) NULL,
	[Territory] [varchar] (2) NULL,
	[MdNumber] [varchar] (4) NULL,
	[Latitude] [varchar] (9) NULL,
	[Longitude] [varchar] (9) NULL,
	[AgentName] [varchar] (50) NULL,
	[ActiveStopCount] [int] NOT NULL,
	[LapsedStopCount] [int] NOT NULL,
	[PreferCity] [varchar] (27) NULL,
	[MaxPcLeadType] [varchar] (2) NULL
) ON [PRIMARY]
